package com.busi.wms.model;

import java.util.Map;

import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Model;
import com.zcurd.common.tool.DbMetaTool;


public class WmsTray extends Model<WmsTray> {
	private static final long serialVersionUID = 1L;
	public static final WmsTray me = new WmsTray();
	
	
	public Map<String, Object> getDictDataLoc_id() {
		return DbMetaTool.getDictData("select cast(id as varchar)as id, loc_name from wms_location","zcurd_busi");
	}


	public String getStorageBylocId(int loc_id) {
		// TODO Auto-generated method stub
		return Db.queryStr("select b.storage_name from wms_location a left join wms_storage b on  a.storage_no=b.id where a.id=?", loc_id);
	}	
}
